Interview Questions

1. What is a managed provider?

Options:

a. Managed Provider provides a simplified data access architecture that often results in improved performance without the loss of functional capabilities.

b. Managed providers directly expose provider-specific behavior to consumers through methods and properties.

c. Managed providers work within the boundaries of the Common Language Runtime (CLR).

d. All the above.

Reveal Answer

2. What is the Managed provider for Microsoft Sqlserver Database?

Options:

a. System.Data.SqlClient

b. System.Data.OracleClient

c. System.Data.Oledb

d. System.Data.Odbc

e. All the above

Reveal Answer

3. Can we enable or disable the connection pool?

Options:

a. Yes

b. No

Reveal Answer

4. What is the core ADO.Net assembly?

Options:

a. System.Data.dll

b. System.Data.SqlClient.dll

c. System.Data.Linq.dll

d. System.Data.Linq.dll

Reveal Answer

5. What is the namespace for MS SQLServer Compact database?

Options:

a. System.Data.SqlClient

b. System.Data

c. System.Data.SqlServerCe

d. System

Reveal Answer

6. Which of the following is correct about Oledb Managed Provider?

Options:

a. Oledb provider is .NET component

b. Oledb is COM component

c. Oledb provider provides standard interface for SQL server only.

d. None

Reveal Answer

7. How can we specify port number in Connection String in App.Config file?

Options:

a. Connection String ="server=.\sqlexpress,portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword".

b. Connection String ="server=.\sqlexpress; portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword".

c. Connection String ="server=.\sqlexpress;Database=dbname;Uid=dbuser; Pwd=dbpassword;Port Number=number".

d. Connection String ="server=.\sqlexpress; portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword;Port=Port Number"

Reveal Answer

8. @@Identity contains last identity value over given connection

Options:

a. Yes

b. No

Reveal Answer

9. Can we have multiple .config files along with App.Config file?

Options:

a. Yes

b. No

Reveal Answer

10. The return type for ExecuteNonQuery() is ______________

Options:

a. void

b. int

c. String

d. char

Reveal Answer

11. SQL Server, Oracle, Sybase etc., are _________________

Options:

a. Databases

b. COM Components

c. RDBMS Products.

d. DCOM Components

Reveal Answer

12. Which of the following connection string is in correct format?

Options:

a. <add name="Demo" ConnectionString="DataSource=Server;Initial Catalog=pubs;user id=sa;pwd=password"/>

b. <add name= ”Demo” ConnectionString=” server=.\sqlexpress; database=”ADODB“ ;user id=sa ; pwd=password"/>

c. <add name = ”Demo” ConnectionString=” server=.\sqlexpress; database=ADODB ;user id=sa ; pwd=password"/>

d. <add name = ”Demo” ConnectionString=” server=sqlexpress; database=ADODB ;user id=sa ; pwd=password"/>

Reveal Answer

13. Private void Form1_Load (object Sender,EventArgs e) { SqlConnection con = new SqlConnection(); try { con.ConnectionString = @"Data Source = server;Initial Catalog = pubs; User Id= sa; pwd = Password"; con.Open() MessageBox.Show(“Test”); } } What is the output?

Options:

a. Test

b. Connection string was not in correct format

c. Compile time Error

d. None

Reveal Answer

14. private void Form1_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); try { con.ConnectionString = @"Data Source =server; Initial Catalog = pubs;userid=sa;password=password"; con.Open(); } finally { if (con.State == ConnectionState.Open) MessageBox.Show("Connection Successful"); else MessageBox.Show("Unsuccessful"); } } What is the output?

Options:

a. Connection Successful

b. Unsuccessful. Then runtime error Keyword not supported userid

c. Compilation Error

Reveal Answer

15. private void Form1_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); using (con) { con.ConnectionString = @"Data Source =server;Initial Catalog = pubs;user Id=sa;password=password"; con.Open(); MessageBox.Show(con.State.ToString()); } MessageBox.Show(con.State.ToString()); } What is the output?

Options:

a. Open

b. Close

c. Open , Close

d. None

Reveal Answer

16. What is the using statement?

Options:

a. To control objects life time.

b. All The resources are cleaned up deterministically

c. The class which implements IDisposable should be used in the using statement

d. All the above

Reveal Answer

17. Can we add relations between the tables in dataset?

Options:

a. Yes

b. No

Reveal Answer

18. Why is DataSet slower than DataReader?

Options:

a. As “DataSet” is connected architecture, has live connection while reading data.

b. “DataSet” carry considerable overhead because of relations; multiple tables etc speed is slower than “DataReader”.

Reveal Answer

19. How can we force the connection object to close after my data reader is closed?

Options:

a. It will closes automatically when datareader closes.

b. By using CommandBehavior.CloseConnection enumeration

c. Using Connection.ImmediateClose().

d. Using CommandBehaviour.Connection.Close().

Reveal Answer

20. Can we add relations between the tables in dataset?

Options:

a. Yes

b. No

Reveal Answer

21. What is the wildcard character in SQL?

Options:

a. SQL wildcards can be used when searching for data in a database

b. SQL wildcards can substitute for one or more characters when searching for data in a database.

c. SQL wildcards must be used with the SQL LIKE operator

d. All the above.

Reveal Answer

22. What is ACID stands for in rule of thumb of transactions ?

Options:

a. Asynchronous ,Connected, Identity ,Disconnected

b. Atomic , Connection, Isolated, Durable.

c. Atomic, Connection, Identity, Disconnected.

d. Atomic, Consistent, Isolated, Durable.

Reveal Answer

23. What happens internally if the statement cmd.Prepare() is executed in the Frontend?

Options:

a. The execution plan is cached by the backend.

b. The execution plan cached can be reused for subsequent request.

c. Same execution plan can be reused for different data.

d. All the above

Reveal Answer

24. Which method do you invoke on the DataAdapter control to load your generated dataset with data?

Options:

a. Update()

b. Fill()

c. Load()

d. Set()

Reveal Answer

25. .In order to bind the data source to the Repeater control what are the property to set , and what method you should call?

Options:

a. DataSource Property and DataBind method

b. DataMember Property and DataBinding method

c. DataSource Property and Dispose method.

d. ItemSource Property and Item Bind Method.

Reveal Answer

26. What authentication will be the best practice for connecting to sqlserver ?

Options:

a. Windows Authentication

b. Sql server Authentication

Reveal Answer

27. What are the steps to follow to avoid SQL Injection attacks?

Options:

a. Always use Storedprocedures instead of creating SQL commands.

b. Using Parameterized queries

c. By using the controlled input values from user and checking with expected values.

d. All the above.

Reveal Answer

28. When select or similar type of sql statement is executed a new cursor is created on the _________.

Options:

a. back end

b. front end

c. can't say

d. No cursor was created

Reveal Answer

29. The cursor and pointers functionality is encapsulated by the ___________ object in the front end.

Options:

a. command

b. data object

c. datareader object

d. connection object

Reveal Answer

30. The cursor managed by Data Reader is _______________.

Options:

a. read only

b. forward-only

c. read-write

d. both read and forward

Reveal Answer

31. Is it compulsory that every opened connection must be closed?

Options:

a. yes

b. No

c. can't say

Reveal Answer

32. For a connection object to share a common connection in the pool, their connection strings _________

Options:

a. must match

b. can be different

c. Just Data source must be same

d. none of the above

Reveal Answer

33. In an SQL statement the value of every Varchar field must be enclosed in _________

Options:

a. single quotes

b. double quotes

c. brackets

d. none

Reveal Answer

34. To open more than one data reader on one connection object at a time ______ should be added.

Options:

a. MultipleActiveResultSets=False

b. SingleActiveResultSets=True

c. MultipleActiveResultSets=True

d. SingleActiveResultSets=False

Reveal Answer

35. Every prepared statement must be framed using the ______________

Options:

a. parameters

b. arguments

c. methods

d. constructors

Reveal Answer

36. If the statement is marked as _______________ then for further usage this execution plan is cached by the backend, so that the same plan can be reused for the subsequent request for the same statement but different data.

Options:

a. proper

b. prepared

c. parametized

d. Ready

Reveal Answer

37. In Sql server the parameters must begin with ______________

Options:

a. #

b. @

c. ^

d. *

Reveal Answer

38. In oracle the parameters must begin with ___________

Options:

a. @

b. *

c. ?

d. the name is sufficient

Reveal Answer

39. For OleDb and Odbc providers, the parameters must begin with ___________.

Options:

a. @

b. *

c. ?

d. the name is sufficient

Reveal Answer

40. If the SQL statement has to be executed only once, don't mark it prepared because the backend _____________

Options:

a. takes extra time.

b. efficiency decreases.

c. degrades performance

d. is not to be executed

Reveal Answer

41. _______________ is a precompiled set of sql statement which are compiled in native form and stored in the backend.

Options:

a. procedures

b. stored procedures

c. Mars

d. None

Reveal Answer

42. Stored procedures are ____________ in execution.

Options:

a. Moderate

b. slow

c. fast

Reveal Answer

43. __________________ is a group of Sql statements to be executed as one unit to modify the state of database.

Options:

a. Stored procedures

b. Transaction

c. collection

d. None of the above

Reveal Answer

44. __________________ is a disconnected object model for working with the data fetched from database

Options:

a. Transaction

b. DataSet

c. DataType

d. DataReader

Reveal Answer

45. Dataset is __________ of the database.

Options:

a. Dependent

b. Independent

c. Can't say

d. Component

Reveal Answer

46. In Dataset, server's scalability is _____________

Options:

a. increased

b. decreased

c. remains same

d. none

Reveal Answer

47. In DataSet, network traffic is ______________

Options:

a. Reduced

b. Increased

c. Remains same

d. None

Reveal Answer

48. As Dataset is _____________, it can be used for exchanging of data between distributed objects.

Options:

a. disconnected

b. connected

c. can't say

Reveal Answer

49. If read-only and forward only access to data is required then it is preferred to use ______________.

Options:

a. DataSet

b. DataReader

c. Transaction

d. None

Reveal Answer

50. ____________________ can be used for getting the reference to all child rows for a given parent row and to get the reference to the parent row of a given child row

Options:

a. Dataset

b. datareader

c. DataRelation

d. Transanction

Reveal Answer

51. What are the two major components of ADO.NET?

Options:

a. Data Reader and DataSet

b. XML and Delegates

c. LINQ and XML

d. Dataset and XML.

Reveal Answer

52. ____________ is designed for accessing of data from various sources.

Options:

a. DataSet

b. Data Reader

c. DataAdapter

d. DataGrid

Reveal Answer

53. Full name of ADO in ADO.NET? //Full form of ADO is

Options:

a. Anonymous Data Object

b. Asynchronous Data Objects

c. ActiveX Data Options

d. ActiveX Data Objects

Reveal Answer

54. ____________ is the best option to use when there is an extensive operation on the retrieved data. In this the connection is closed immediately after fetching the data.

Options:

a. DataSet

b. Data Reader

c. DataAdapter.

d. DataGrid.

Reveal Answer

55. Which of these are the valid Data Providers for .net?

Options:

a. SQL Server .Net Data Provider

b. ODBC .net Data Provider

c. OLE DB .NET Data Provider

d. All the above

Reveal Answer

56. ____________ is used to move data between a dataset and data source.

Options:

a. Data Table

b. Data View

c. Data Adapter

d. Data Reader

Reveal Answer

57. Can odbc connection be used to connect to SQL Server?

Options:

a. Yes

b. No

Reveal Answer

58. and are primary components of a Data Table.

Options:

a. DataColumn & DataCell

b. DataRow & DataField

c. Data field & DataColumn

d. DataRow & DataColumn

Reveal Answer

59. _______________ defines the schema of the table.

Options:

a. DataRow

b. DataColumn

c. DataColumnCollection

d. DataRowCollection

Reveal Answer

60. ____________ contains actual data for the table.

Options:

a. DataRow

b. DataColumn

c. DataColumnCollection

d. DataRowCollection

Reveal Answer

61. Can we add Constraints (Ex: Foreign Key) to DataTable?

Options:

a. Yes

b. No

Reveal Answer

62. ExecuteNonQuery() is used for___________________

Options:

a. Execution of statements which do not return any data from backend to front end.

b. Execution of statements which return only one value.

c. Execution of statements which return multiple rows and columns

d. Exection of statements which return only columns.

Reveal Answer

63. Object ExecuteScalar() is used for__________________

Options:

a. Execution of statements which do not return any data from backend to front end.

b. Execution of statements which return only one value.

c. Execution of statements which return multiple rows and columns

d. None

Reveal Answer

64. ExecuteNonQuery() returns _____ when a rollback occurs

Options:

a. 0

b. 1

c. -1

d. null

Reveal Answer

65. Can SqlCommand.CommandText have more than one Sql statement

Options:

a. Yes

b. No

Reveal Answer

66. _______________ makes block of code transactional?

Options:

a. TransactionScope

b. Transaction

c. Using

d. Procedure

Reveal Answer

67. Once a transaction has begin over a connection, a command without its transaction property set, cannot be executed on that connection unless either the transaction is committed or rolledback.

Options:

a. True

b. False

c. Can’t Say.

Reveal Answer

68. If DataAdapter.Update is executed and the number of records affected by execution of this command is zero then it throws ___________________exception.

Options:

a. ArgumentNullException

b. InvalidOperationException

c. DBConcurrencyException

d. NullReferenceException

Reveal Answer

69. When the DataGridView control is binded to DataTable, it actually binds to the ________________ of that DataTable?

Options:

a. DefaultView

b. DataSource

c. TableView of selected table.

d. TableView

Reveal Answer

70. __________ indicates the status of the row.

Options:

a. Row State

b. Row Version

c. Row Status

d. All the above

Reveal Answer

71. What are the RowState values in ADO.NET?

Options:

a. Changed

b. Active

c. Updated

d. Deleted

e. All the Above

Reveal Answer

72. What are the values of DataRowVersion?

Options:

a. CurrentRow

b. Cascasde

c. Original

d. Prepared

Reveal Answer

73. DataTable.Rows.Find is used for?

Options:

a. To locate a record by Foreign Key

b. To locate a record by Primary Key

c. To locate a record by any column name.

d. To locate a record by Foreign key and Primary key

Reveal Answer

74. __________ is used to send a null value as a SQLParameter.

Options:

a. null

b. Nothing

c. “ ”

d. DBNull.Value

Reveal Answer

75. _____________ is a mechanism to minimize the cost of creating and opening a new connection.

Options:

a. Connection Pooling

b. Connection Collector

c. Pooler

Reveal Answer

76. Dispose method is automatically called with __________ statement.

Options:

a. using

b. foreach

c. switch

d. for

Reveal Answer

77. The DataSet is stored in ___________.

Options:

a. Memory representation of the database

b. Harddisk

c. In browser

Reveal Answer

78. Which of the following is ADO.NET objects?

Options:

a. SqlConnectionCommand object

b. SqlDataAdapter object

c. SqlCommand object

d. SqlQueryCommand object.

Reveal Answer

79. What steps would you follow and what objects would you use to quickly find the number of records in a database table?

Options: Reveal Answer

80. What is the code execution process in Sqlclient,oracle client and ODP.net?

Options:

a. Managed code

b. Unmanaged code

Reveal Answer

81. Which of the following is not supported by ADO.NET?

Options:

a. Record sets, Client-side Cursors,Dataset

b. DataReader, Client-side Cursors, Server- side Cursors

c. Record sets, Client-side Cursors, Server-side Cursors

d. DataReader, Record sets, Dataset

Reveal Answer

82. In How many directions we can pass the parameters in stored procedure?

Options:

a. Only Input

b. Only Output

c. Input,Output and InputOutput

d. Only InputOutput

Reveal Answer

83. Transactions can be implemented in:

Options:

a. Ado.net

b. Dbms

c. Both (a) & (b)

d. None

Reveal Answer

84. How many connections can we have by default?

Options:

a. 50

b. 100

c. 150

d. 200

Reveal Answer

85. Is it is possible to jump to nth record directly using DataReader?

Options:

a. Yes

b. No

c. None

Reveal Answer

Interview Questions and Answer

Packages

Trending Certification Courses:

Microsoft Mock Exams:

Other links

About

Resources